Query Variables

A Query Variable allows you to define a named, typed value that can be injected into your data-source queries at runtime. You can create, view, edit, and delete query variables from the Data → Query Variable screen.

---

List View

On the Query Variable page, you’ll see a table of all variables defined for the current project:

Name	Type	Actions
Variables	string	🔍 View • ✏️ Edit • 🗑 Delete
Variable_12	string	🔍 View • ✏️ Edit • 🗑 Delete

• Name – The unique identifier you’ll use in your query (e.g. {{ Variables }}).
• Type – The data type for the variable (e.g. string, number, boolean, etc.).
• Actions –
  • 🔍 View opens a read-only overview
  • ✏️ Edit opens the configuration dialog
  • 🗑 Delete removes the variable

---

Creating or Editing a Query Variable

Click New Query Variable (top right) or the ✏️ Edit icon to open the variable dialog:

Field	Description
Name	A unique, alphanumeric identifier (required).
Type	Select the variable’s data type from the dropdown (required).
Value	The default value to use when the query runs (required). Must match the selected type.

1. Name Enter a unique name (e.g. customerId).

2. Type Choose from:

   • string
   • number
   • boolean
   • date
   • etc.

3. Value Provide the default value.

   • For a string, wrap letters in quotes if needed.
   • For a number, simply enter digits.
   • For a boolean, enter true or false.

4. Click OK to save, or Cancel to discard changes.

---

Usage in Queries

Once defined, reference your query variable in any SQL or API integration step using the Liquid-style syntax:

  SELECT *
  FROM users
  WHERE id = {{ customerId }}
  At runtime, {{ customerId }}

will be replaced by the value you set (or supplied programmatically via the flow).

tip

Keep your variable names short and descriptive. Avoid spaces or special characters—use camelCase or underscores.